package Servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import model.Company;

import org.json.JSONException;

import sqltool.SQLConn;
import function.Module;

public class loginServlet extends HttpServlet {
	/**
	 * Constructor of the object.
	 */
	public loginServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request, response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 * 
	 * This method is called when a form has its tag value method equals to
	 * post.
	 * 
	 * @param request
	 *            the request send by the client to the server
	 * @param response
	 *            the response send by the server to the client
	 * @throws ServletException
	 *             if an error occurred
	 * @throws IOException
	 *             if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		SQLConn db = new SQLConn();
		Connection conn;
		Statement stmt;
		ResultSet rs;

		PrintWriter out = response.getWriter();
		String username = request.getParameter("account");
		String password = request.getParameter("password");

		conn = db.getconnection();
		try {
			stmt = conn.createStatement();
			rs = stmt
					.executeQuery("select * from company where company_name = '"
							+ username + "'");
			if (rs.next()) {
				if (username != null
						&& password.equals(rs.getString("company_password"))) {

					out.println("login success");
				} else {
					out.print("longin failure");
				}
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

		/*
		 * out.print(username); out.print(password);
		 */

		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 * 
	 * @throws ServletException
	 *             if an error occurs
	 */
	public void init() throws ServletException {
	}

}
